package cn.stylefeng.guns.modular.common.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface CommonMapper {
    @Select(" select EQP_CLASS_NAME,EQP_CLASS_CODE from TC_EQUIPMENT_CLASS")
    List<Map> getEqpTypeList();

    @Select("SELECT STATION_CODE,STATION_NAME FROM B_STATION")
    List<Map> getEqpStation();

    @Select("SELECT to_char(ORG_ID)ORG_ID,ORG_NAME FROM SYS_HR_ORGDATA")
    List<Map> getOrgids();

    @Select("SELECT ITEMCODE,ITEMNAME FROM B_ITEM")
    List<Map> getItemList();

    @Select("SELECT ROUTE_CODE,ROUTE_NAME FROM TC_ROUTE")
    List<Map> getRouteList();

    @Select("SELECT to_char(ORG_ID)ORG_ID,ORG_NAME  FROM SYS_HR_ORGDATA WHERE ORG_PARENT_ID=#{parentId}")
    List<Map> getParentOrgids(String parentId);

}
